--------------------------------------------------------
--  DDL for Table SYS_OBJECT_SUBSTITUTION
--------------------------------------------------------

  CREATE TABLE "OBJECT_SUBSTITUTION" 
   (	
  "APPLICATION_KEY" VARCHAR2(36 BYTE), 
  "ID" VARCHAR2(32 BYTE), 
	"OBJECT_ID" VARCHAR2(32 BYTE), 
	"OBJECT_NAME_LOCAL" VARCHAR2(100 BYTE), 
	"OBJECT_NAME_ENGLISH" VARCHAR2(100 BYTE), 
	"PARENT_ID" VARCHAR2(32 BYTE), 
	"OLEVEL" NUMBER, 
	"ORDER_ID" NUMBER, 
	"ACTIVE" VARCHAR2(1 BYTE)
   );
--------------------------------------------------------
--  DDL for Index SYS_OBJECT_SUBSTITUTION_PK
--------------------------------------------------------
  CREATE UNIQUE INDEX  "OBJECT_SUBSTITUTION_PK" ON "OBJECT_SUBSTITUTION" ("APPLICATION_KEY", "ID") ;
--------------------------------------------------------
--  Constraints for Table SYS_OBJECT_SUBSTITUTION
--------------------------------------------------------
  ALTER TABLE "OBJECT_SUBSTITUTION" MODIFY ("OBJECT_ID" NOT NULL ENABLE);
  ALTER TABLE "OBJECT_SUBSTITUTION" MODIFY ("ID" NOT NULL ENABLE);
